.jpg)
| Field Name | Description |
|---|---|
| DB Connections | Select the DB Connections used on this File Definition. This is a design time setting, and can be overridden with run time setting on the Action. |
| Transaction Identification | Select the method to use for flagging transactions as processed. This only applies when the DB Definition is used as the source of a Map (exporting data). |
| Duplicate Record Handling | Select the method to handle duplicate records when importing data. This only applies when the DB Definition is used as the destination of a map (importing data). |
| Use In-Memory Check | Select to enable the Duplicate Record Handling check to be performed in memory rather than via individual SQL statements. |
| Disable automatic string trim | Disable the automatic trimming of blank spaces from the start and end of strings. |
| Save Null Fields as Blank String | Enables generated SQL statements to use blank strings for any fields with null values. This only applies when the DB Definition is used as the destination of a map (importing data). |
| Save Blank String Fields as Null | Treats fields with blank string values as nulls. This works with Include null values in SQL Statements. This only applies when the DB Definition is used as the destination of a map (importing data). |
| Include null values in SQL Statements | Enables generated SQL statements to include null values for any fields with null values. This only applies when the DB Definition is used as the destination of a map (importing data). |